<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="FriendDataSet" targetNamespace="http://tempuri.org/FriendDataSet.xsd" xmlns:mstns="http://tempuri.org/FriendDataSet.xsd" xmlns="http://tempuri.org/FriendDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="SocialNetworkConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="SocialNetworkConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.WLQuickApps.SocialNetwork.Data.Properties.Settings.GlobalReference.Default.SocialNetworkConnectionString" Provider="System.Data.SqlClient">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FriendTableAdapter" GeneratorDataComponentClassName="FriendTableAdapter" Name="Friend" UserDataComponentName="FriendTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SocialNetworkConnectionString (Settings)" DbObjectName="SocialNetwork.dbo.Friend" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[Friend] ([RequesterUserID], [RequestedUserID], [IsConfirmed], [CreateDate]) VALUES (@RequesterUserID, @RequestedUserID, @IsConfirmed, @CreateDate)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@RequesterUserID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="RequesterUserID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@RequestedUserID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="RequestedUserID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsConfirmed" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsConfirmed" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT RequesterUserID, RequestedUserID, IsConfirmed, CreateDate FROM dbo.Friend</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="RequesterUserID" DataSetColumn="RequesterUserID" />
              <Mapping SourceColumn="RequestedUserID" DataSetColumn="RequestedUserID" />
              <Mapping SourceColumn="IsConfirmed" DataSetColumn="IsConfirmed" />
              <Mapping SourceColumn="CreateDate" DataSetColumn="CreateDate" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="SocialNetworkConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="ConfirmFriendship" Modifier="Public" Name="ConfirmFriendship" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="ConfirmFriendship">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>UPDATE       Friend
SET                IsConfirmed = 'true'
where 
RequesterUserID = @requesterUserID AND
RequestedUserID = @requestedUserID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="requesterUserID" ColumnName="RequesterUserID" DataSourceName="SocialNetwork.dbo.Friend" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@requesterUserID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="RequesterUserID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="requestedUserID" ColumnName="RequestedUserID" DataSourceName="SocialNetwork.dbo.Friend" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@requestedUserID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="RequestedUserID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
              <DbSource ConnectionRef="SocialNetworkConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="CreateFriendRequest" Modifier="Public" Name="CreateFriendRequest" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy1" UserSourceName="CreateFriendRequest">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>INSERT INTO [dbo].[Friend] ([RequesterUserID], [RequestedUserID], [IsConfirmed], [CreateDate]) VALUES (@requesterUserID, @requestedUserID, 'false', CURRENT_TIMESTAMP)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="requesterUserID" ColumnName="RequesterUserID" DataSourceName="SocialNetwork.dbo.Friend" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@requesterUserID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="RequesterUserID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="requestedUserID" ColumnName="RequestedUserID" DataSourceName="SocialNetwork.dbo.Friend" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@requestedUserID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="RequestedUserID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="SocialNetworkConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetFriendsByUserID" GetMethodModifier="Public" GetMethodName="GetFriendsByUserID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetFriendsByUserID" UserSourceName="GetFriendsByUserID1">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>WITH PageTable AS
(
SELECT RequesterUserID, RequestedUserID, IsConfirmed, CreateDate 

		, ROW_NUMBER() over (ORDER BY CreateDate) as RowID

FROM dbo.Friend 
Where 
IsConfirmed = 'true' AND
(
RequesterUserID = @userID OR
RequestedUserID = @userID 
)
)

select * from PageTable
where RowID between (@startRowIndex + 1) and (@startRowIndex + @maximumRows)

</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="userID" ColumnName="RequesterUserID" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@userID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="RequesterUserID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@startRowIndex" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@maximumRows" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SocialNetworkConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="GetFriendsByUserIDCount" Modifier="Public" Name="GetFriendsByUserIDCount" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy2" UserSourceName="GetFriendsByUserIDCount">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT COUNT(*)
FROM dbo.Friend 
Where 
IsConfirmed = 'true' AND
(
RequesterUserID = @userID OR
RequestedUserID = @userID 
)
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="userID" ColumnName="RequesterUserID" DataSourceName="SocialNetwork.dbo.Friend" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@userID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="RequesterUserID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SocialNetworkConnectionString (Settings)" DbObjectName="SocialNetwork.dbo.Friend" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetPendingFriendInvitations" GetMethodModifier="Public" GetMethodName="GetPendingFriendInvitations" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetPendingFriendInvitations" UserSourceName="GetPendingFriendInvitations1">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT RequesterUserID, RequestedUserID, IsConfirmed, CreateDate FROM dbo.Friend
where
RequestedUserID = @userID and
IsConfirmed = 'false'</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="userID" ColumnName="RequestedUserID" DataSourceName="SocialNetwork.dbo.Friend" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@userID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="RequestedUserID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SocialNetworkConnectionString (Settings)" DbObjectName="SocialNetwork.dbo.Friend" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetPendingFriendRequests" GeneratorSourceName="FillBy1" GetMethodModifier="Public" GetMethodName="GetPendingFriendRequests" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetPendingFriendRequests" UserSourceName="GetPendingFriendRequests1">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT RequesterUserID, RequestedUserID, IsConfirmed, CreateDate FROM dbo.Friend
WHERE 
RequesterUserID = @userID AND
IsConfirmed = 'false'</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="userID" ColumnName="RequesterUserID" DataSourceName="SocialNetwork.dbo.Friend" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@userID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="RequesterUserID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SocialNetworkConnectionString (Settings)" DbObjectName="SocialNetwork.dbo.Friend" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="LookupFriendRequest" GeneratorSourceName="LookupFriendRequest1" GetMethodModifier="Public" GetMethodName="LookupFriendRequest" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="LookupFriendRequest" UserSourceName="LookupFriendRequest1">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT RequesterUserID, RequestedUserID, IsConfirmed, CreateDate FROM dbo.Friend
where 
RequesterUserID = @requesterUserID and
RequestedUserID = @requestedUserID and
IsConfirmed = 'false'</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="requesterUserID" ColumnName="RequesterUserID" DataSourceName="[SocialNetwork].dbo.Friend" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@requesterUserID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="RequesterUserID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="requestedUserID" ColumnName="RequestedUserID" DataSourceName="[SocialNetwork].dbo.Friend" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@requestedUserID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="RequestedUserID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SocialNetworkConnectionString (Settings)" DbObjectName="SocialNetwork.dbo.Friend" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="LookupFriendStatus" GeneratorSourceName="FillBy3" GetMethodModifier="Public" GetMethodName="LookupFriendStatus" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="LookupFriendStatus" UserSourceName="LookupFriendStatus1">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT RequesterUserID, RequestedUserID, IsConfirmed, CreateDate FROM dbo.Friend 
where 
(RequestedUserID = @firstUserID OR
RequesterUserID = @firstUserID) 
AND
(RequestedUserID = @secondUserID OR
RequesterUserID = @secondUserID) 
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="firstUserID" ColumnName="RequestedUserID" DataSourceName="SocialNetwork.dbo.Friend" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@firstUserID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="RequestedUserID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="secondUserID" ColumnName="RequestedUserID" DataSourceName="SocialNetwork.dbo.Friend" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@secondUserID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="RequestedUserID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SocialNetworkConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="RemoveFriendship" Modifier="Public" Name="RemoveFriendship" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy3" UserSourceName="RemoveFriendship">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>DELETE FROM Friend
where
(
RequesterUserID = @requesterUserID OR
RequestedUserID = @requesterUserID
) AND (
RequesterUserID = @requestedUserID OR
RequestedUserID = @requestedUserID
)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="requesterUserID" ColumnName="RequesterUserID" DataSourceName="SocialNetwork.dbo.Friend" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@requesterUserID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="RequesterUserID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="requestedUserID" ColumnName="RequesterUserID" DataSourceName="SocialNetwork.dbo.Friend" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@requestedUserID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="RequesterUserID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="SocialNetworkConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="RemoveUserFriendships" Modifier="Public" Name="RemoveUserFriendships" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy4" UserSourceName="RemoveUserFriendships">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>DELETE FROM Friend
WHERE        (RequesterUserID = @userID) OR
                         (RequestedUserID = @userID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="userID" ColumnName="RequesterUserID" DataSourceName="SocialNetwork.dbo.Friend" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@userID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="RequesterUserID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="FriendDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="FriendDataSet" msprop:Generator_DataSetName="FriendDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Friend" msprop:Generator_UserTableName="Friend" msprop:Generator_RowDeletedName="FriendRowDeleted" msprop:Generator_RowChangedName="FriendRowChanged" msprop:Generator_RowClassName="FriendRow" msprop:Generator_RowChangingName="FriendRowChanging" msprop:Generator_RowEvArgName="FriendRowChangeEvent" msprop:Generator_RowEvHandlerName="FriendRowChangeEventHandler" msprop:Generator_TableClassName="FriendDataTable" msprop:Generator_TableVarName="tableFriend" msprop:Generator_RowDeletingName="FriendRowDeleting" msprop:Generator_TablePropName="Friend">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="RequesterUserID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="RequesterUserID" msprop:Generator_ColumnPropNameInRow="RequesterUserID" msprop:Generator_ColumnVarNameInTable="columnRequesterUserID" msprop:Generator_ColumnPropNameInTable="RequesterUserIDColumn" type="xs:string" />
              <xs:element name="RequestedUserID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="RequestedUserID" msprop:Generator_ColumnPropNameInRow="RequestedUserID" msprop:Generator_ColumnVarNameInTable="columnRequestedUserID" msprop:Generator_ColumnPropNameInTable="RequestedUserIDColumn" type="xs:string" />
              <xs:element name="IsConfirmed" msprop:Generator_UserColumnName="IsConfirmed" msprop:Generator_ColumnPropNameInRow="IsConfirmed" msprop:Generator_ColumnVarNameInTable="columnIsConfirmed" msprop:Generator_ColumnPropNameInTable="IsConfirmedColumn" type="xs:boolean" />
              <xs:element name="CreateDate" msprop:Generator_UserColumnName="CreateDate" msprop:Generator_ColumnPropNameInRow="CreateDate" msprop:Generator_ColumnVarNameInTable="columnCreateDate" msprop:Generator_ColumnPropNameInTable="CreateDateColumn" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>